UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OxG6eo5BA2e9ZDM0g1132g/u/i0Ga+DwisGRrWeq6Do='
WHERE
key_id = 'bead554dd9f2e1793026910f925273a72abcea25347e5f7b938d8159968bd256'
AND (
token = 'OxG6eo5BA2e9ZDM0g1132g/u/i0Ga+DwisGRrWeq6Do='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)