UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C6yAMXnpQpubbb2/lFHImNEavTBrIvLU1MXKabZfHpo='
WHERE
key_id = '9220179472569216a66d4e032395d12429af49f23d521782a5806ae5d8fcc76b'
AND (
token = 'C6yAMXnpQpubbb2/lFHImNEavTBrIvLU1MXKabZfHpo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)