UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PYRmIIrwRMa8mYCaJbIA4Hr5bHazfZ86mELnIebCwNo='
WHERE
key_id = 'db0a987450d93d4c44595d457a22071ff67776aa880acc5f2f93964de9b884bb'
AND (
token = 'PYRmIIrwRMa8mYCaJbIA4Hr5bHazfZ86mELnIebCwNo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)