UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jhfpk5ZhYem+jwmPhCxytJKalpT3zr5sRXUNmevgflQ='
WHERE
key_id = '740bfa5198712ee04f2b770f4f0022185cccc443a40f837393ad504f6eb4f4df'
AND (
token = 'Jhfpk5ZhYem+jwmPhCxytJKalpT3zr5sRXUNmevgflQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)