UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X7GqL+LmWHkgo8AZ8ajV6BVoQ7He0m662kuXp0CjZ7Q='
WHERE
key_id = '9b756b46a04d4d254d8a0250e29da7261223a35770e49f6931ee3ad182214a9a'
AND (
token = 'X7GqL+LmWHkgo8AZ8ajV6BVoQ7He0m662kuXp0CjZ7Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)