UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VY9qDd22M94mUFEjRjYJQXkVBpc2a2E/KYDL8xdky/Q='
WHERE
key_id = '8a0a555887f87fb9ff7a6edf35e939b4f9da1107184b30d083773447707267a9'
AND (
token = 'VY9qDd22M94mUFEjRjYJQXkVBpc2a2E/KYDL8xdky/Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)