UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZMyycPBtNzL0gJdFFHENha9Ghvfuq4UQlcup3qOjnrE='
WHERE
key_id = 'b166d1f50ca04a0abd52637093d48cb4ba9136e10cb97cba5e512ebbce5dd040'
AND (
token = 'ZMyycPBtNzL0gJdFFHENha9Ghvfuq4UQlcup3qOjnrE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)