UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2mj6PRl5dL/zMsvU3m3A19PnWszNbzB3g337EU3HYtU='
WHERE
key_id = '16464b22a4a3e357be5b44f1d00fbbe686ab57627e89d7bf8f4c39b1afdde36c'
AND (
token = '2mj6PRl5dL/zMsvU3m3A19PnWszNbzB3g337EU3HYtU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)