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