UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I6qYfUJPihCi0cyTdEywbc4uRqJgjyAd5cvwM9mihX4='
WHERE
key_id = '18767e63593262816ac52c4a1d3dbeeedbbb82f6dd0790f5311ca43b49b79b29'
AND (
token = 'I6qYfUJPihCi0cyTdEywbc4uRqJgjyAd5cvwM9mihX4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)