UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HtN2ygBF03KTQv4HJG5Eqr2q7VWckl7iYMvKydDa27c='
WHERE
key_id = '97b9407d6db854e560179790b48188f41ca56ad737dd2109bdc5c9ba0c364877'
AND (
token = 'HtN2ygBF03KTQv4HJG5Eqr2q7VWckl7iYMvKydDa27c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)