UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZrWSZ5632aDJdjV9AcsCLam/8hGI1hJ/XfMaFnnBhFU='
WHERE
key_id = 'd2384dc45b4502642cc8805d8a7c28cbdf191988be8204d785904f02786255cc'
AND (
token = 'ZrWSZ5632aDJdjV9AcsCLam/8hGI1hJ/XfMaFnnBhFU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)