UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S6+C/VaOtQDLcgHNPLjFUPsEDkvi1DUXeei6aXSPC4I='
WHERE
key_id = '0569b971b32885cff81f47f4bfc933a509e376b0f124ab993fbb2d3f9e9afc3a'
AND (
token = 'S6+C/VaOtQDLcgHNPLjFUPsEDkvi1DUXeei6aXSPC4I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)