UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BXZkA3u7qG2gZRsERFVQ9cDtWlgLQiPabFhjNkhtUJw='
WHERE
key_id = '37a6edf1fe64501c304e500549614506ebad1bbf65e28253b99472db1077f8fb'
AND (
token = 'BXZkA3u7qG2gZRsERFVQ9cDtWlgLQiPabFhjNkhtUJw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)