UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ncXP2gYl4O6MO+LSwAGGI65Jhz+GGDGNwRNxQ57teqk=' 
WHERE 
  key_id = '038245aa4120b4f91039e9feae95a35b71babffc3f26ee112e0e59250093a028' 
  AND (
    token = 'ncXP2gYl4O6MO+LSwAGGI65Jhz+GGDGNwRNxQ57teqk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037