UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'piAYCIGZkLihg+sVfvYxfg9QrdyF6HJgApyIdgiMwhQ='
WHERE
key_id = '010f636631c679719d61231581f1eb8ef72f5564fdd54fa39a5942d9a2216902'
AND (
token = 'piAYCIGZkLihg+sVfvYxfg9QrdyF6HJgApyIdgiMwhQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)