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

Query time 0.00045