UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TvEgF6NP2rqzxrueWSfMgL30PTdqjmSKk4UCUn/o3x8='
WHERE
key_id = '46a1898144b36c6901bda2085f86f540e737e4b1a74c3ffe755ef7c4a9a973b6'
AND (
token = 'TvEgF6NP2rqzxrueWSfMgL30PTdqjmSKk4UCUn/o3x8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)