UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3SFiU7vEj5ZTkUDFSewvDqqvpW1GO1vKYXhtJ8vyzOo='
WHERE
key_id = 'd5ad526e6d5ec35750320b5bd9e52dcf5d0959d3948a72e3df060a41090978ca'
AND (
token = '3SFiU7vEj5ZTkUDFSewvDqqvpW1GO1vKYXhtJ8vyzOo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)