UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bsKKd4eP/V0wcpmMcC1pigwJCflxCAi7DGjP+IJPRSo='
WHERE
key_id = '2ca90239b0580ba6cc5621ef821d96928097980862e7c0302714dda8e7076ea0'
AND (
token = 'bsKKd4eP/V0wcpmMcC1pigwJCflxCAi7DGjP+IJPRSo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)