UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pPtDDmVkLRI8JhWbe0UiWiAYoPE9qO+xGD2Os3cbrx8='
WHERE
key_id = 'e88ec6c0412fbe9627c79bac949c517c14a59e2ef02025053f1299af33b88ada'
AND (
token = 'pPtDDmVkLRI8JhWbe0UiWiAYoPE9qO+xGD2Os3cbrx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)