UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZdatluA/8tBW72cKnUNa5HtXmuEyeNmhACIBcm7e474='
WHERE
key_id = 'd0d1daef5c9c50f08ac5c1934fc7be8125a5ed72b996a4926f05608f1b7a7f69'
AND (
token = 'ZdatluA/8tBW72cKnUNa5HtXmuEyeNmhACIBcm7e474='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)