UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fhgoganiSOf1Kc2sEcGxOAXN4C4jiIzvxD3AsUDWz6Y='
WHERE
key_id = 'dab46d8e9a48b06687d9f9f2e6517ad93ab4c974be5b3af9de5a721a89b933aa'
AND (
token = 'fhgoganiSOf1Kc2sEcGxOAXN4C4jiIzvxD3AsUDWz6Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)