UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qvp7+t2phvmQUgFrmUH4jQm9L0/Twear9mrpZQosCOw='
WHERE
key_id = 'b56ad635296d9b817bdd8412123ad644c3f34309c516997e61e7f1d36b499630'
AND (
token = 'qvp7+t2phvmQUgFrmUH4jQm9L0/Twear9mrpZQosCOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)