SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '09b7cf4d4cc0e5e437dc7f4705ef9d52cf72230f65274a5b729ce476c59b2e49' 
  AND token = 'RdM1GDxQc216U4tx1EaEQ7o8dw5ONeQ68NVl5SSQzW8=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00038

JSON explain

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