UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VxLEZBMcIWQJNCS4IT1r4w5Sfas43M0uXOpGTajAq2A='
WHERE
key_id = '00307a7e7ace0a1432fe16bf3aaf23b0638ed70692ecd2908404ba04ab56cd9f'
AND (
token = 'VxLEZBMcIWQJNCS4IT1r4w5Sfas43M0uXOpGTajAq2A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)