UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2z9h8BMTpqkzSrYJ3Y1ArlKNz+03++MwPAvoGmyPswM='
WHERE
key_id = '2e8ad3c7894c2e9b2198f626b03e27c1fb4668593c422f3367467016fe19e651'
AND (
token = '2z9h8BMTpqkzSrYJ3Y1ArlKNz+03++MwPAvoGmyPswM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)