UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oi6oVvAFF8Ognl63hPDIrHzPVdS1O3UNEpudPH8+9oc='
WHERE
key_id = '81c9b66866aa41e0c81f5e62238ba7f2fbcb811fa47a77b69b3ad3005ff5c71e'
AND (
token = 'oi6oVvAFF8Ognl63hPDIrHzPVdS1O3UNEpudPH8+9oc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)