UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ni5hdpnnuuGlwT9jFGvYMpP3+4zSBOcGCy5aR9J3vw0='
WHERE
key_id = 'b8b0b1687cafc5f6179bcba5e2d6e9f7acea96c90441ed8df93c87d6349042cf'
AND (
token = 'Ni5hdpnnuuGlwT9jFGvYMpP3+4zSBOcGCy5aR9J3vw0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)