SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '354b597297a516c05dcfdb18d02a482fa5e678738b1e8fa8ab175c8bc1823bd4' 
  AND token = 'HDuC0KSZYvAISCgjMv0sf7PmHa15jO9208RXjG9yrpQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00038

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}