UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zgkcC8be3p+iQpcE6oQ3m8nG4BP2tJ2s7SGGPccet3k='
WHERE
key_id = '9f1f4c1dbdeadb2044abacd2d3e7d49964577384e8218dd3d75e25089ac89e96'
AND (
token = 'zgkcC8be3p+iQpcE6oQ3m8nG4BP2tJ2s7SGGPccet3k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)