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