UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v46umuQ2lzIehOv3TJS8y/LA7uUjd9mL0CINt/KbWf4='
WHERE
key_id = 'b5d872f92aa1112049cd9b1501377a08470c1dc15d3f8416f08c9f861ed4e850'
AND (
token = 'v46umuQ2lzIehOv3TJS8y/LA7uUjd9mL0CINt/KbWf4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)