UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'y5Kt6xAG1VxK7v2ukkTzpHQccZOE/EfanuugrWZx0A0=' 
WHERE 
  key_id = '7009a26c9de0986e2bc8f2c4d62bab5ffa6d9f5b01c43aa59d16d1544146d010' 
  AND (
    token = 'y5Kt6xAG1VxK7v2ukkTzpHQccZOE/EfanuugrWZx0A0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025