SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '670d0d09dbeced599bfee87504d49f4b46046248614569c9ccf41a49218c7530' 
  AND token = 'HUoTYWy4mTzI52z+jU0HXl9QBQRCc6L4oFEIOGWiKH4=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00031

JSON explain

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