UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zDzsaD4NENVqKOkKl0KI4IaO4eVOKa0NNBXGUOwQ2mU='
WHERE
key_id = '48b010f4927fa08c50336e1b1bc38aa4cadf52ac95959485551cd6a9b3651517'
AND (
token = 'zDzsaD4NENVqKOkKl0KI4IaO4eVOKa0NNBXGUOwQ2mU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)