UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EAjIuubCvsrG1ikjtn0pOxeByHGaa9TQYeBhODdJvz4='
WHERE
key_id = 'e30ea145d3a0158b21bb7c7d834bb51370ddf1f02b1e8604ab32db8f2f9500c5'
AND (
token = 'EAjIuubCvsrG1ikjtn0pOxeByHGaa9TQYeBhODdJvz4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)