UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2dWIgAyz44E+GUSeH2hlv+BEMkYFn8w1X3fzWqSsASU='
WHERE
key_id = 'ddf7e2cf21eb78940f28252cb9f347e697172ea63627cba8520874c2e9bb0e5a'
AND (
token = '2dWIgAyz44E+GUSeH2hlv+BEMkYFn8w1X3fzWqSsASU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)